CREATE TABLE [dbo].[Meet_Resources]
(
[PRODUCT_CODE] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Resources_PRODUCT_CODE] DEFAULT (''),
[RESOURCE_TYPE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Resources_RESOURCE_TYPE] DEFAULT (''),
[RES_GROUP] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Resources_RES_GROUP] DEFAULT (''),
[CODE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Resources_CODE] DEFAULT (''),
[LINE_NO] [int] NOT NULL CONSTRAINT [DF_Meet_Resources_LINE_NO] DEFAULT ((0)),
[FLD1_QTY] [numeric] (15, 4) NOT NULL CONSTRAINT [DF_Meet_Resources_FLD1_QTY] DEFAULT ((0)),
[FLD1_TIME] [datetime] NULL,
[FLD1_CHECK] [bit] NOT NULL CONSTRAINT [DF_Meet_Resources_FLD1_CHECK] DEFAULT ((0)),
[FLD1_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Resources_FLD1_ID] DEFAULT (''),
[NOTE] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[Meet_Resources] ADD CONSTRAINT [PK_Meet_Resources] PRIMARY KEY CLUSTERED ([PRODUCT_CODE], [RESOURCE_TYPE], [RES_GROUP], [CODE]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Meet_Resources] TO [IMIS]
GRANT SELECT ON  [dbo].[Meet_Resources] TO [IMIS]
GRANT INSERT ON  [dbo].[Meet_Resources] TO [IMIS]
GRANT DELETE ON  [dbo].[Meet_Resources] TO [IMIS]
GRANT UPDATE ON  [dbo].[Meet_Resources] TO [IMIS]
GO